--Execute as sys
ALTER SYSTEM SET result_cache_max_size = 2M SCOPE = MEMORY;

SELECT name, value
FROM   v$parameter
WHERE  name = 'result_cache_max_size';
